View Raw Logs from Live or Disk

If logging is enabled in Live Log mode on the current endpoint, the live log file can be viewed in real time. To view the live log, select File > Live Logs.

To stop the view automatically scrolling as new log entries are received, deselect Options > Auto Scroll.

1. Select File > Open Log File.

   A file browse dialog displays.

2. Select an ETL log file and click Open.

   Environment Manager Monitor loads the log file. The loading progress displays at the bottom of the dialog. The log file may take a few minutes to load depending on its size, event types and event detail

1. Select File > Recent Log Files.

   A list of recently used log files displays.

2. Select a log file to open.

   Environment Manager Monitor loads the log file. The loading progress displays at the bottom of the dialog. The log file may take a few minutes to load depending on its size, event types and event detail.

1. Right-click a column heading

2. Select Column Chooser.

   The Customization dialog displays.

   

3. Drag a column from the Customization dialog into the desired position on the header row.

1. Right-click a column heading.
2. Select a sort order:
   • Sort Ascending - Sort the data in ascending order.
   • Sort Descending - Sort the data in descending order.
3. To clear the sorting, right-click the column heading and select Clear Sorting.

This option displays all of the unique values for a field, such as all Session IDs, from the open log file. Columns can be filtered by a specific value from the dataset.

1. Hover over a column heading and click the filter icon.

   A list of unique values within the column displays.

   

2. Select a value on which to filter the selected column.

   The data is filtered to show only entries that match the criteria.

The Auto Filter Row displays above the dataset and allows columns to be filtered by entering basic filtering criteria.

1. Select View > Filters > Auto Filter Row.

   The Auto Filter Row displays below the column headings.

2. To filter a column, enter the text into the Auto Filter Row.

   

   The data is filtered to show only entries that match the criteria entered in the Auto Filter Row.

3. To clear the filtering, select View > Filters > Clear.

The Filter Editor allows conditions to be created to target specific data in the dataset. Complex conditions can be created by using multiple expressions and nested Boolean operators.

1. Select View > Filters > Filter Editor.

2. Edit the condition as required:

   • Click a red Boolean operator, such as And, to edit the operator or add a new condition group.
   • Click a blue field name, such as [Time Stamp], to change the field to match.
   • Click a green operator, such as Equals, to edit the operator.
   • Click either <enter a value> or a black value to enter a value.

   • Click to add a new expression to the condition.

     

3. Click Apply to preview the filter.

4. Click OK.

   The data is filtered to show only entries that match the criteria entered in the Filter Editor.

5. To clear the filtering, select View > Filters > Clear.

1. Select View > Groups > Group By Box.

   The Group By box displays above the column headings.

2. Drag a column heading into the Group By box. More columns can be dragged into the Group By box to create nested groupings.

   

   The data is grouped by the fields specified in the Group By box.

3. To clear the grouping, right-click the Group By box and select Clear Grouping.

1. Select Edit > Find Panel.The Find Panel displays above the column headings.

   Enter a search term.

2. Click Find.Rows containing text in any column that matches the entered search term are displayed.
3. To clear the search, click Clear in the Find Panel or close the Find Panel.

Conditional formatting allows rows or text to be formatted based upon the data within one or more fields.

1. Select Tools > View > Formatting Editor.

   The Formatting Editor dialog displays.

2. Click Add to add a new condition. Edit the condition as required:
   • Click a red Boolean operator, such as And, to edit the operator or add a new condition group.
   • Click a blue field name, such as [Time Stamp], to change the field to match.
   • Click a green operator, such as Equals, to edit the operator.
   • Click either <enter a value> or a black value to enter a value.
   • Click to add a new expression to the condition.

3. Once the condition has been constructed, set the formatting properties for rows that match the condition. Available options include row background color, row border color and text formatting.

   

4. Click Apply to preview the conditional formatting.
5. Click OK.
6. Rows matching the criteria specified in the Formatting Editor are formatted.
7. To clear the formatting, select View > Formatting > Clear.

The footer allows statistics to be displayed for one or more fields. The sum, minimum, maximum, count, and average values are available for each field.

1. Select View > Footer.

   The footer displays above the status bar.

2. Below a column, right-click the footer. Select a statistic from the following options:
   • Sum
   • Min
   • Max
   • Count

   • Average

   The statistic displays in the footer and automatically updates as data is added or removed.

   

One or more log lines can be copied to a new tab to allow the data to be analyzed independently. Tabs can be renamed to make it easier to work with multiple tabs.

1. Select one or more log lines from the log file. Multiple lines can be selected by using the Ctrl or Shift keys.
2. Select Edit > Copy To New Tab
3. A new tab is created containing the selected log lines.
4. To rename the created tab, right-click the tab and select Rename.

Data from two tabs can be merged and compared in a single view. The rows are color-coded to differentiate between the two sources.

1. Select the first tab to compare.

2. Select Tools > Compare With.

   A list of open tabs displays.

3. Select a tab to compare with the current tab.

   The Compare Tabs dialog displays.

   Log lines that are present in both tabs display in white, those from only the first tab display in red and those from only the second tab display in yellow.

   

4. Click to access merge and compare options.

   

5. Change the options as required and click Refresh. The following options are available:
   • Visible - Change the columns that are displayed in the comparison.

   • Calculated - Change the columns that are used for the comparison.

     The merged data is displayed with the specified columns visible.

Look up system error codes from the log file using the built-in tool.

1. Click Tools > Error Code Lookup.

   The Error Code Lookup dialog displays.

2. Enter an error code.

3. Click .

   The error information displays for the entered error code.